package com.qzimp.fujiancuo.mapper;

import com.mybatisflex.core.BaseMapper;
import com.qzimp.fujiancuo.entity.Cuo;
import com.qzimp.fujiancuo.entity.Region;
import org.apache.ibatis.annotations.Select;

import java.io.Serializable;
import java.util.List;

/**
 *  映射层。
 *
 * @author 吴宗波
 * @since 2024-11-21
 */
public interface RegionMapper extends BaseMapper<Region> {

    @Select("select tb_cuo.* from tb_cuo ,tb_region where tb_cuo.provice_id = tb_region.id and tb_region.id = #{id}")
    List<Cuo> selectById(Serializable id);
}
